Click Here!
home account info subscribe login search My ITKnowledge FAQ/help site map contact us


 
Brief Full
 Advanced
      Search
 Search Tips
To access the contents, click the chapter and section titles.

Oracle Performance Tuning and Optimization
(Publisher: Macmillan Computer Publishing)
Author(s): Edward Whalen
ISBN: 067230886x
Publication Date: 04/01/96

Bookmark It

Search this book:
 
Table of Contents


Appendix F
Contents of the CD-ROM

This appendix lists the contents of the CD-ROM disc that accompanies this book. Included on the disc are the SQL scripts used to create many of the examples in the book.

SQL Scripts

The following sections give brief descriptions of the SQL scripts used as examples in this book; the scripts are provided on the CD-ROM disc.

Chapter 9

09opt01.sql Extract library cache-miss percent.
09opt02.sql Extract library cache-miss rate.
09opt03.sql Extract data dictionary area cache-miss percent.
09opt04.sql Extract data dictionary area cache-miss rate.
09opt05.sql Extract buffer cache information.
09opt06.sql Extract physical I/O information.
09opt07.sql Create striped tablespace.
09opt08.sql Create table on that tablespace with stripe.
09opt09.sql Create chained rows table and analyze.
09opt11.sql Check dynamic rollback segment growth.
09opt10.sql Check recursive calls.
09opt12.sql Check rollback segment statistics.
09opt13.sql Check for rollback segment contention.
09opt14.sql Check for log buffer contention.
09opt15.sql Check for latch contention.
09opt16.sql Check sort performance.
09opt17.sql Check for free list contention.

Chapter 10

10opt01.sql Look for tablespace fragmentation.
10opt02.sql Create DOGS table.
10opt03.sql Create BREEDS table.
10opt04.sql Load BREEDS table.
10opt05.sql Load DOGS table.
10opt06.sql Create dog_space tablespace.
10opt07.sql Create dog_cluster.
10opt08.sql Create DOGS2 table in dog_cluster.
10opt09.sql Create BREEDS2 table in dog_cluster.
10opt10.sql Create index on dog_cluster.
10opt11.sql Load BREEDS2.
10opt12.sql Load DOGS2.


NOTE:  The CD-ROM contains two versions of the same tables: DOGS and DOGS2, and BREEDS and BREEDS2. One set of tables has constraints defined within the table; the other set uses alternative table commands.

Chapter 16

16opt01.sql Create a striped tablespace.
16opt02.sql Create a striped table.

Chapter 25

25opt01.sql Create tablespace dog_space and create tables DOGS and BREEDS.
25opt02.sql Insert rows into BREEDS table.
25opt03.sql Insert rows into DOGS table.
25opt04.sql Select sid, serial# and osuser from V$SESSION.
25opt05.sql Turn on SQL Trace for session.
25opt06.sql Turn off SQL Trace for session.
25opt07.sql Select join from DOGS and BREEDS.
25opt08.bat Run TKPROF.
25opt09.sql Create plan_table.
25opt10.sql EXPLAIN PLAN example.
25opt11.sql Set up plan_table.
25opt12.sql Extract execution plan from plan_table.

Chapter 27

27opt01.sql ANALYZE TABLE with COMPUTE STATISTICS.
27opt02.sql ANALYZE TABLE with ESTIMATE STATISTICS.
27opt03.sql ANALYZE TABLE with ESTIMATE STATISTICS with SAMPLE.
27opt04.sql ANALYZE TABLE with VALIDATE STRUCTURE.
27opt05.sql ANALYZE TABLE with LIST CHAINED ROWS INTO.
27opt06.sql ANALYZE TABLE with LIST CHAINED ROWS.

Chapter 28

28opt01.sql Create stored procedure old_dogs.

Chapter 29

29opt01.txt DOGS table in Wordpad format.
29opt02.txt BREEDS table in Wordpad format.
29opt03.sql ALTER TABLE BREEDS to ADD PRIMARY KEY(breed).
29opt04.sql ALTER TABLE DOGS to ADD FOREIGN KEY BREEDS(breed).
29opt05.sql ALTER TABLE DOGS for CHECK.
29opt06.sql Add dog that fails constraint.
29opt07.sql Add dog that passes constraint.
29opt08.sql CREATE TABLE DOGS and BREEDS with constraints.
29opt09.sql Select constraint information.
29opt10.sql Select constraint information for DOGS table.
29opt11.sql Select column constraint information.
29opt12.sql Add trigger, old_one.
29opt13.sql Add an old dog.

Chapter 32

32opt01.sql CREATE SEQUENCE.
32opt02.sql Use the sequence.
32opt03.sql Demonstrate array processing.


Table of Contents


Products |  Contact Us |  About Us |  Privacy  |  Ad Info  |  Home

Use of this site is subject to certain Terms & Conditions, Copyright © 1996-2000 EarthWeb Inc.
All rights reserved. Reproduction whole or in part in any form or medium without express written permission of EarthWeb is prohibited. Read EarthWeb's privacy statement.